UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oKYHn/VsKDvjDZN092VJ4uWVI1UEmt7WHHWt6KP6QMo='
WHERE
key_id = '5dc789141c82e8780debe599fb5fc1491f8ba0494e5347353c67f66f7f40c097'
AND (
token = 'oKYHn/VsKDvjDZN092VJ4uWVI1UEmt7WHHWt6KP6QMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)