UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PnIQkbaFnzgYWClQ8jkRSmPmLVJ1ese2IShZIp4birI='
WHERE
key_id = '787dec285a75bd59ee30ab1f3a398e373009714edbf9b93f862b72136b8d6cc3'
AND (
token = 'PnIQkbaFnzgYWClQ8jkRSmPmLVJ1ese2IShZIp4birI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)