UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KQHkgJU0vm23gCwiwKcnFbHd8Iw9kWLnljk+v3/dwr4='
WHERE
key_id = 'd0071dab8a1643b81aee988ed4a26c179b45d52b763cf08e0b25d180a926c1e9'
AND (
token = 'KQHkgJU0vm23gCwiwKcnFbHd8Iw9kWLnljk+v3/dwr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)