UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YypB6auECJ0f7/zmJaTHSUsyWWbFEIMGMT2mZy5zH4='
WHERE
key_id = '8a4a1932a68c1234598f503e7cb08d24632e37e2a851231764f0b33032ac0baf'
AND (
token = '8YypB6auECJ0f7/zmJaTHSUsyWWbFEIMGMT2mZy5zH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)