UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nbPxuPqHJS1WO8pnGsjU6LWQZXQrOmkhkpx5NSkqdFY='
WHERE
key_id = 'fd1b099a06c6531ed98b59f9935b2f5da2102967353feea002a1be54715a6ced'
AND (
token = 'nbPxuPqHJS1WO8pnGsjU6LWQZXQrOmkhkpx5NSkqdFY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)