UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TwyTqCGkVDVxiJLv91q87Uz0W/Y/XpHeYgxQ8MQ89H0='
WHERE
key_id = '97f8b207161a41d0c5339f6c971de6ea7351b8f44919c9004036433cb9ec33d0'
AND (
token = 'TwyTqCGkVDVxiJLv91q87Uz0W/Y/XpHeYgxQ8MQ89H0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)