UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/xob9QcM9839V/vy4L1GOmRjDZym6vVMwdmXHsACYT0='
WHERE
key_id = 'f92af079df8f19fc041c2570b44de5fbabe99801043161ef4ae2f2256711d1e0'
AND (
token = '/xob9QcM9839V/vy4L1GOmRjDZym6vVMwdmXHsACYT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)