UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BZRQj28P4lLiKIyu13tNXx7jynimZ2LGMRi8Cz7jZkI='
WHERE
key_id = '13c261b4f1844163f5da44338b70df34a64b94c5f2a4baa24dd975ab8c08a736'
AND (
token = 'BZRQj28P4lLiKIyu13tNXx7jynimZ2LGMRi8Cz7jZkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)