UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HnP7OvOqz6IMemoycR6+GHoQK/B4fwhpeYRhQxh+3go='
WHERE
key_id = 'adeed62c8f39c0b28f7e68c9bfc5f41932c14204fcd7c0e79f638307a5fa9858'
AND (
token = 'HnP7OvOqz6IMemoycR6+GHoQK/B4fwhpeYRhQxh+3go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)