UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VqKf50ZdTbwYE9tTioA3b0UXyWBHippmlha3RJIgYIE='
WHERE
key_id = 'f5caa7ff82b929d7f9376c0e41cdf0463f07337af4f0b93985f706a49fa4ec21'
AND (
token = 'VqKf50ZdTbwYE9tTioA3b0UXyWBHippmlha3RJIgYIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)