UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U/Prh3l0EhoCJ6jKE6GhuMFdToyiMB6MUuko8vjjRVc='
WHERE
key_id = '9ed72803354d68cf848b51faf8b3c8af0976dd8d47c051b3804e568108e5623d'
AND (
token = 'U/Prh3l0EhoCJ6jKE6GhuMFdToyiMB6MUuko8vjjRVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)