UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B293Sqqkd0LRxv1AEwc1ssxIxBQjHPvvnvyweJm0GlE='
WHERE
key_id = '7e35e0804ef12bb5fa21c466ff1c070927b0c3917efdad3b650f217a98198ce6'
AND (
token = 'B293Sqqkd0LRxv1AEwc1ssxIxBQjHPvvnvyweJm0GlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)