UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eTJQyMW0CTK1uEASpkgGkFJt/OXsnjBLecpcpVWVe7o='
WHERE
key_id = 'b3a595378db8516e27ffc646bd74efad01380f886c7b384532ec5d0d0c978c1f'
AND (
token = 'eTJQyMW0CTK1uEASpkgGkFJt/OXsnjBLecpcpVWVe7o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)