UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0MzZgOdusKj4POups6hBzpZvd2W+zJkvy5ooYPqMBc4='
WHERE
key_id = '4d6ba0d0ccf5af531e8418ee36505aa02fe3d82159f253f224a6e3c5f4be73e9'
AND (
token = '0MzZgOdusKj4POups6hBzpZvd2W+zJkvy5ooYPqMBc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)