UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XKFq6Wr4z5ig1KPo7RS6XxeILJPhlYPOVmRgj7ap30='
WHERE
key_id = '0d2f4ef5d9452c473835551d234c6d5510a69680aa27aa73cf6f6956c11e8ffd'
AND (
token = '/XKFq6Wr4z5ig1KPo7RS6XxeILJPhlYPOVmRgj7ap30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)