UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tMyLItYpyIhzB+97ekdaXrBLSQ8RSHmjVelM+v2/2os='
WHERE
key_id = 'c4a1240dba638111d1eb36c7d9e4e939888dbe51842afdab81ff711a28b394c1'
AND (
token = 'tMyLItYpyIhzB+97ekdaXrBLSQ8RSHmjVelM+v2/2os='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)