UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8C4rsjucPVYqJMfOtybv4Rsk5uNNGbAMYtrUi/a+mPU='
WHERE
key_id = '24fe00bd3b897738c24717287e70a898bf142e8715c423eca37172d6dd3d0056'
AND (
token = '8C4rsjucPVYqJMfOtybv4Rsk5uNNGbAMYtrUi/a+mPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)