UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p7Gspge9YuHv4VoiOR52LpPVW4ENbaeNFzhXunK/Ajk='
WHERE
key_id = 'e29ae09641af68c9e4bbb2cd80cd081e6eb33f01c895ada474bfd4032b780317'
AND (
token = 'p7Gspge9YuHv4VoiOR52LpPVW4ENbaeNFzhXunK/Ajk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)