UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qD/ynC6JK0z9Elbt3gcGyT5HR5sCftaybnrjQPRSSUs='
WHERE
key_id = 'a07f8a33f5955106cd75a588d9222bb793d9b81a92c621c16b91390fb52ee7d2'
AND (
token = 'qD/ynC6JK0z9Elbt3gcGyT5HR5sCftaybnrjQPRSSUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)