UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TRpY+SBApp3xKim0YX8bd0dDqV5Eojmn/q6UJCdoq+k='
WHERE
key_id = 'b8ee93105d4cfb75ccfecaa4337d5f9e533cc95d61f03ca327527792e4efb0a0'
AND (
token = 'TRpY+SBApp3xKim0YX8bd0dDqV5Eojmn/q6UJCdoq+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)