UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jKsgzaTAADo04U1EUPhATDRjm07L0UGO7SYpIZvhy8o='
WHERE
key_id = '59711301a17975f653eedb85f9a8f77b1eb99e376efe9c73989e74ece14ebb33'
AND (
token = 'jKsgzaTAADo04U1EUPhATDRjm07L0UGO7SYpIZvhy8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)