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