UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WGdkPAub7L5YUqZg/jHYdczpKmtw8JhCvQV6hpaR+To='
WHERE
key_id = 'e7c5c1670f509054dfc907be35bce7038d6c65be98ef081d8daefc835391d2a3'
AND (
token = 'WGdkPAub7L5YUqZg/jHYdczpKmtw8JhCvQV6hpaR+To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)