UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VjHmqImShRW36J8kdYw4Y3FvTr5LT9WCxNN9iKLVNtQ='
WHERE
key_id = 'a79be13b16368521324535bd2331ea081c8727e051950a38b990e13fcab0b982'
AND (
token = 'VjHmqImShRW36J8kdYw4Y3FvTr5LT9WCxNN9iKLVNtQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)