UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1LpeG/L9zLwmnqRsJbeur7RtAjHkFnebQyedpQ20Q/g='
WHERE
key_id = '7cc231a8ba91c1dd733b68546b0a2f427204526890cd1673fab7a9968eeaa9c5'
AND (
token = '1LpeG/L9zLwmnqRsJbeur7RtAjHkFnebQyedpQ20Q/g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)