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