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