UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zUoBI5cc9T5jKKIEhY/slWP2Pf6fOUABZGab8Bc0X9U='
WHERE
key_id = '4f2a6bc5de83f2e5b711ec1c0851564c46d4c2ce944ff0137f9a7febc8cbaff3'
AND (
token = 'zUoBI5cc9T5jKKIEhY/slWP2Pf6fOUABZGab8Bc0X9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)