UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XhR9fB5mzoq28HfcUbLf/OIWKYuA6ysEvG3bvwJAm1s='
WHERE
key_id = 'e3990fef7d78d33bd96dc7989279aade44267272149f1fba492bd2e2bb58ba9f'
AND (
token = 'XhR9fB5mzoq28HfcUbLf/OIWKYuA6ysEvG3bvwJAm1s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)