UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YI7qCYqfFHpe5S7t5i1A+AQT2VXHKBS0ZKzhUJpuYO4='
WHERE
key_id = 'c563aff0a28228b62aa7c0ee3e388cb1860cc3928d820a3349e770881735e4d5'
AND (
token = 'YI7qCYqfFHpe5S7t5i1A+AQT2VXHKBS0ZKzhUJpuYO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)