UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S6x6jjBYWlU9bHqs13Rx3K00oaDIt7IgCITHSz8VnfA='
WHERE
key_id = '1f34af37196bcd88e6c08eaf2a0d3aa9b4f4d8b3ee31371ab9d5d8b593844572'
AND (
token = 'S6x6jjBYWlU9bHqs13Rx3K00oaDIt7IgCITHSz8VnfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)