UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/6DwNmlw/qiF9oBdbY4JXpuRqLfc76DEs/5RGJhsX3A='
WHERE
key_id = '81614f76a324b295025b2202fc5bb887408a689e3a9cc56f0c4d8070aac1fb4e'
AND (
token = '/6DwNmlw/qiF9oBdbY4JXpuRqLfc76DEs/5RGJhsX3A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)