UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l8lkEbSkhgnPv44NvrnvOsWShHIxUWZpi4uTy6rvL7g='
WHERE
key_id = '027e02c63fe6c9a1ef9c4949c33ac311f30faaa5d762d75430901174d1343b14'
AND (
token = 'l8lkEbSkhgnPv44NvrnvOsWShHIxUWZpi4uTy6rvL7g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)